package com.yunjijia.mapper;


import java.util.List;

import com.yunjijia.pojo.User;
import org.apache.ibatis.annotations.Param;


public interface UserMapper {


    int deleteByPrimaryKey(String userid);

    int insert(User record);

    int insertSelective(User record);

    User selectByPrimaryKey(String userid);

    int updateByPrimaryKeySelective(User record);

    int updateByPrimaryKey(User record);

    List<User> selectByNameOrPhone(@Param("username") String username, @Param("telphone") String telphone);

    //批量删除
    void deleteByIds(@Param("list") List<String> itemIds);

    //更新每月的花费
    void updateCost(@Param("userid") String userid, @Param("cost") Double totalPay);

    //精确查询
    User selectByidcartAndtel(@Param("idcart") String idcart, @Param("telphone") String telphone);


    User selectByName(@Param("username") String username);

    List<User> findAllUser();
}